create sequence kinva_seq01;
create sequence kinva_seq_pro;

create table u1(id number primary key,uname varchar2(10));

insert into u1(id,uname) values(kinva_seq01.nextval,'Kinva1');

select * from u1;

select * from emp;

select * from emp where ename in ('SMITH','WARD');

select * from(select ename,rownum rn from emp) where rn>2 and rn<7; 



select * from emp,dept where (emp.deptno = DEPT.deptno);

select * from emp left join DEPT on emp.deptno = DEPT.deptno;


select deptno,avg(SAL) from emp group by deptno;


create table customer(id number primary key,cname varchar2(10),age number);

select kinva_seq01.nextval from dual;

select * from customer;

delete from customer where id=23;

update customer set cname='heihei',age=10  where id=31
